
<%@ page import="controllers.BestOfRegionConnect" %>
<%@ page import="controllers.CommonConnect" %>
<%@ page import="java.util.List,java.text.*"%>
<%@ page import="java.util.List, java.util.HashMap" %>
<%@ page import="java.util.Date;import java.util.Calendar;"%>
   <style type="text/css" title="currentStyle">
			@import "../../media/dataTables/css/demo_page.css";
			@import "../../media/dataTables/css/demo_table_jui.css";
			@import "../../media/themes/smoothness/jquery-ui-1.7.2.custom.css";
		</style>
		<script type="text/javascript" language="javascript" src="../../media/dataTables/js/jquery.js"></script>
		<script type="text/javascript" language="javascript" src="../../media/dataTables/js/jquery.dataTables.js"></script>
        <script type="text/javascript">
        $(document).ready(function () {
            $("#Americas").dataTable({
                "sPaginationType": "full_numbers",
                "bJQueryUI": true
            });                       
        });
        
        $(document).ready(function () {
            $("#China").dataTable({
                "sPaginationType": "full_numbers",
                "bJQueryUI": true
            });                          
        });
        
        $(document).ready(function () {
            $("#South-East-Asia").dataTable({
                "sPaginationType": "full_numbers",
                "bJQueryUI": true
            });                          
        }); 
        
            $(document).ready(function () {
                $("#Europe").dataTable({
                    "sPaginationType": "full_numbers",
                    "bJQueryUI": true
                });
        });
            
        $(document).ready(function () {
            $("#Pacific-Rim").dataTable({
                "sPaginationType": "full_numbers",
                "bJQueryUI": true
            });                          
            
        });       
   
        
        function getYear() {
        	//var selYear = document.forms[0].chkBenefits[document.forms[0].chkBenefits.selectedIndex].text;
           var selYear = document.getElementById('chkBenefits')[document.getElementById('chkBenefits').selectedIndex].innerHTML;	
        	document.location.href = "/modules/default/find-solution-sub-best-of-regions.jsp?openform&selYear="+selYear;     
            
        	   	  	}
        
       
        </script>
        

<!-- content -->
<!--<a id="mainContent" name="mainContent"/>-->
<div id="lotusContent">
<div class="lotusLayout lotusHeader">
<!--<h1>Savvy Solutions</h1>
<div class="lotusDetails">The Global Operations Excellence collection of Savvy Solutions resulting in cost savings for the company</div>-->
</div>
<!-- View selector -->
<div class="lotusActionBar lotusBtnContainer">
<!-- Buttons -->
<!--<b>Savvy Solutions for Srinivas Vanamala:</b> -->
<!--<span class="lotusBtn lotusBtnAction lotusLeft">
<a href="/blogs/roller-ui/myblogs/newentry">New Entry</a>
</span>-->
</div>


<% 


 String getYear1 = request.getParameter("selYear");
 CommonConnect NOM1 = new  CommonConnect(); 
 List<HashMap<String,Object>> rs1 = NOM1.getYearBestRegion();  
 


%>
<table>
<tr>
<td></td>
<td width="17%"> Select Year: </td><td>
<input name="%%Surrogate_cmbMonth" type="hidden" value="1">

<select name="selY" id="chkBenefits" class="text-edit">
<option >--Select Year--</option>
<% for(int i = 0 ; i < rs1.size() ;i++){
      if	(getYear1.equals(rs1.get(i).get("BestYearRegion").toString())){
%>
              <option selected ="selected" value="<%= rs1.get(i).get("BestYearRegion")%>"><%=rs1.get(i).get("BestYearRegion")%></option>
<%    }else{%>
               <option><%=rs1.get(i).get("BestYearRegion")%></option>
<%         }
}%>
</select>

</td><td width="45%"><span class="lotusBtn lotusBtnAction lotusLeft">
<a href="javascript:getYear()"><b>Show</b></a>
</span></td>

<td width="15%"> <img valign="top" src="/img/best_of_region_pic.jpg"></td>
</tr>
</table>


<% 
 String getYear2 = request.getParameter("selYear");
 BestOfRegionConnect NOM = new  BestOfRegionConnect(); 
 List<HashMap<String,Object>> rs = NOM.getQuery("bestOfRegionYear", getYear2);  
%>
  
<div id="dt_example" onload="javascript:getYear()">
    <div id="container">
        <div id="demo_jui">       
      <h2><b> Best of Regions --  Americas </b></h2>	
	<table cellpadding="0" cellspacing="0" border="0" class="display" id="Americas" onload="javascript:setde()">
          <thead>
              <tr>
                        <th>SolutionID</th>
						<th>SolutionTitle</th>
						<th>Site</th>
						<th>Customer</th>
						<th>Benefit Results</th>
						<th>Achieved</th>	
						<th>Quarter</th>
              </tr>
          </thead>
          <tbody>
        		<% for(int i = 0 ; i < rs.size() ;i++){
        			if (rs.get(i).get("Region").toString().equals("Americas"))
        			{
				%>
		  <tr>
		    <td><a href="/modules/default/display-solution.jsp?sol_id=<%=rs.get(i).get("solID")%>"><%=rs.get(i).get("solCode")%></a></td>
		    <td><%=rs.get(i).get("Title")%></td>
		    <td><%=rs.get(i).get("Site")%></td>
			<td><%=rs.get(i).get("Customer")%></td>
			<td><%=rs.get(i).get("BenefitResult")%></td>
			<td><%=rs.get(i).get("Achieved")%></td>
			<td><%=rs.get(i).get("Quarter")%></td>
		   
		  </tr>
		<% }
           }%>
          </tbody>
      </table>
	  </div>
    </div>
</div>

<br/>
<div id="dt_example">
    <div id="container">
        <div id="demo_jui">       
      <h2><b> Best of Regions --  China  </b></h2>	
	<table cellpadding="0" cellspacing="0" border="0" class="display" id="China">
          <thead>
              <tr>
                        <th>SolutionID</th>
						<th>SolutionTitle</th>
						<th>Site</th>
						<th>Customer</th>
						<th>Benefit Results</th>
						<th>Achieved</th>	
						<th>Quarter</th>
              </tr>
          </thead>
          <tbody>
        		<% for(int i = 0 ; i < rs.size() ;i++){
        			if (rs.get(i).get("Region").toString().equals("China"))
        			{
				%>
		  <tr>
		    <td><a href="/modules/default/display-solution.jsp?sol_id=<%=rs.get(i).get("solID")%>"><%=rs.get(i).get("solCode")%></a></td>
		    <td><%=rs.get(i).get("Title")%></td>
		    <td><%=rs.get(i).get("Site")%></td>
			<td><%=rs.get(i).get("Customer")%></td>
			<td><%=rs.get(i).get("BenefitResult")%></td>
			<td><%=rs.get(i).get("Achieved")%></td>
			<td><%=rs.get(i).get("Quarter")%></td>
		   
		  </tr>
		<% }
           }%>
          </tbody>
      </table>
	  </div>
    </div>
</div>

<br/>
<div id="dt_example">
    <div id="container">
        <div id="demo_jui">       
      <h2><b> Best of Regions --  South-East Asia  </b></h2>	
	<table cellpadding="0" cellspacing="0" border="0" class="display" id="South-East-Asia" >
          <thead>
              <tr>
                        <th>SolutionID</th>
						<th>SolutionTitle</th>
						<th>Site</th>
						<th>Customer</th>
						<th>Benefit Results</th>
						<th>Achieved</th>	
						<th>Quarter</th>
              </tr>
          </thead>
          <tbody>
        		<% for(int i = 0 ; i < rs.size() ;i++){
        			if (rs.get(i).get("Region").toString().equals("South-East Asia") )
        			{
				%>
		  <tr>
		    <td><a href="/modules/default/display-solution.jsp?sol_id=<%=rs.get(i).get("solID")%>"><%=rs.get(i).get("solCode")%></a></td>
		    <td><%=rs.get(i).get("Title")%></td>
		    <td><%=rs.get(i).get("Site")%></td>
			<td><%=rs.get(i).get("Customer")%></td>
			<td><%=rs.get(i).get("BenefitResult")%></td>
			<td><%=rs.get(i).get("Achieved")%></td>
			<td><%=rs.get(i).get("Quarter")%></td>
		   
		  </tr>
		<% }
           }%>
          </tbody>
      </table>
	  </div>
    </div>
</div>

<br/>
<div id="dt_example">
    <div id="container">
        <div id="demo_jui">       
      <h2><b> Best of Regions --  Pacific Rim  </b></h2>	
	<table cellpadding="0" cellspacing="0" border="0" class="display" id="Pacific-Rim" >
          <thead>
              <tr>
                        <th>SolutionID</th>
						<th>SolutionTitle</th>
						<th>Site</th>
						<th>Customer</th>
						<th>Benefit Results</th>
						<th>Achieved</th>	
						<th>Quarter</th>
              </tr>
          </thead>
          <tbody>
        		<% for(int i = 0 ; i < rs.size() ;i++){
        			if (rs.get(i).get("Region").toString().equals("Pacific Rim"))
        			{
				%>
		  <tr>
		    <td><a href="/modules/default/display-solution.jsp?sol_id=<%=rs.get(i).get("solID")%>"><%=rs.get(i).get("solCode")%></a></td>
		    <td><%=rs.get(i).get("Title")%></td>
		    <td><%=rs.get(i).get("Site")%></td>
			<td><%=rs.get(i).get("Customer")%></td>
			<td><%=rs.get(i).get("BenefitResult")%></td>
			<td><%=rs.get(i).get("Achieved")%></td>
			<td><%=rs.get(i).get("Quarter")%></td>
		   
		  </tr>
		<% }
           }%>
          </tbody>
      </table>
	  </div>
    </div>
</div>

<br/>
<div id="dt_example">
    <div id="container">
        <div id="demo_jui">       
      <h2><b> Best of Regions --  Europe  </b></h2>	
	<table cellpadding="0" cellspacing="0" border="0" class="display" id="Europe" >
          <thead>
              <tr>
                        <th>SolutionID</th>
						<th>SolutionTitle</th>
						<th>Site</th>
						<th>Customer</th>
						<th>Benefit Results</th>
						<th>Achieved</th>	
						<th>Quarter</th>
              </tr>
          </thead>
          <tbody>
        		<% for(int i = 0 ; i < rs.size() ;i++){
        			if (rs.get(i).get("Region").toString().equals("Europe"))
        			{
				%>
		  <tr>
		    <td><a href="/modules/default/display-solution.jsp?sol_id=<%=rs.get(i).get("solID")%>"><%=rs.get(i).get("solCode")%></a></td>
		    <td><%=rs.get(i).get("Title")%></td>
		    <td><%=rs.get(i).get("Site")%></td>
			<td><%=rs.get(i).get("Customer")%></td>
			<td><%=rs.get(i).get("BenefitResult")%></td>
			<td><%=rs.get(i).get("Achieved")%></td>
			<td><%=rs.get(i).get("Quarter")%></td>
		   
		  </tr>
		<% }
           }%>
          </tbody>
      </table>
	  </div>
    </div>
</div>


</div>
<!--End of Lotus Content-->


<!--End of Lotus Main-->

<!-- Footer gets moved to within Frame div in weblog.vm so closing tags need to go in weblog.vm - MTodd November 1 2007 </body> </html> -->

<input name="$$HTMLDocType" type="hidden" value="&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Strict//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd&quot;&gt;">
<input name="SaveOptions" type="hidden" value="0">
<input name="HTTP_Cookie" type="hidden" value="mailpref=; webchat=1; redirectto=/global/collaboration/SavvySol.nsf/frmHome%3Fopenform; __utma=92377752.1171159035.1345172801.1345172801.1345172801.1; __utmz=92377752.1345172801.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); DomAuthSessId=FB16A96A523B895D2AD9FAA9C64DD351">
<input name="Query_String_Decoded" type="hidden" value="openform&amp;2012">
<input name="Query_String" type="hidden" value="openform&amp;2012">
<input name="dbName" type="hidden" value="global/collaboration/SavvySol.nsf">
<input name="Position" type="hidden" value="">
<input name="curUsername" type="hidden" value="CN=Srinivas Vanamala/OU=SG/OU=Asia/O=Celestica">
<input name="QuickSearch" type="hidden" value="0">
<input name="UserProfileInfo" type="hidden" value="189535317AC64EE385257665005FAC75~4628EE2C7B1ABC70862576880077E8BF~535C09333ABF01B485257654006B0E8D^DTV Process Re-layout~Reduce cosmetic and functional problems at PALM  final quality inspection~Reverse logistics capacity optimization model ^1~0~0^1~0~0">
<input name="txtProfileUNID" type="hidden" value=""></form>
</body>
</html>
